Dataset statistics
| Number of variables | 18 |
|---|---|
| Number of observations | 4207977 |
| Missing cells | 17732808 |
| Missing cells (%) | 23.4% |
| Duplicate rows | 13451 |
| Duplicate rows (%) | 0.3% |
| Total size in memory | 2.7 GiB |
| Average record size in memory | 684.6 B |
Variable types
| Numeric | 7 |
|---|---|
| DateTime | 2 |
| Unsupported | 2 |
| Text | 3 |
| Categorical | 4 |
| Dataset has 13451 (0.3%) duplicate rows | Duplicates |
trip_duration has 2517155 (59.8%) missing values | Missing |
bike_id has 2517155 (59.8%) missing values | Missing |
user_type has 2517652 (59.8%) missing values | Missing |
birth_year has 2560677 (60.9%) missing values | Missing |
gender has 2517155 (59.8%) missing values | Missing |
ride_id has 1690822 (40.2%) missing values | Missing |
rideable_type has 1690822 (40.2%) missing values | Missing |
member_casual has 1690822 (40.2%) missing values | Missing |
trip_duration is highly skewed (γ1 = 575.7622365) | Skewed |
end_station_latitude is highly skewed (γ1 = -73.00992481) | Skewed |
end_station_longitude is highly skewed (γ1 = 73.04144444) | Skewed |
start_station_id is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
end_station_id is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Reproduction
| Analysis started | 2024-01-21 19:17:35.025783 |
|---|---|
| Analysis finished | 2024-01-21 19:22:14.376943 |
| Duration | 4 minutes and 39.35 seconds |
| Software version | ydata-profiling vv4.6.4 |
| Download configuration | config.json |
trip_duration
Real number (ℝ)
MISSING SKEWED
| Distinct | 15182 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 2517155 |
| Missing (%) | 59.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 934.3995 |
| Minimum | 61 |
|---|---|
| Maximum | 20260211 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 64.2 MiB |
Quantile statistics
| Minimum | 61 |
|---|---|
| 5-th percentile | 139 |
| Q1 | 245 |
| median | 383 |
| Q3 | 694 |
| 95-th percentile | 2238 |
| Maximum | 20260211 |
| Range | 20260150 |
| Interquartile range (IQR) | 449 |
Descriptive statistics
| Standard deviation | 23900.616 |
|---|---|
| Coefficient of variation (CV) | 25.578584 |
| Kurtosis | 437929.26 |
| Mean | 934.3995 |
| Median Absolute Deviation (MAD) | 173 |
| Skewness | 575.76224 |
| Sum | 1.5799032 × 109 |
| Variance | 5.7123944 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 244 | 3951 | 0.1% |
| 246 | 3930 | 0.1% |
| 231 | 3903 | 0.1% |
| 235 | 3896 | 0.1% |
| 256 | 3895 | 0.1% |
| 238 | 3893 | 0.1% |
| 239 | 3888 | 0.1% |
| 243 | 3884 | 0.1% |
| 240 | 3883 | 0.1% |
| 252 | 3876 | 0.1% |
| Other values (15172) | 1651823 | |
| (Missing) | 2517155 |
| Value | Count | Frequency (%) |
| 61 | 280 | |
| 62 | 291 | |
| 63 | 337 | |
| 64 | 360 | |
| 65 | 331 | |
| 66 | 354 | |
| 67 | 378 | |
| 68 | 353 | |
| 69 | 427 | |
| 70 | 451 |
| Value | Count | Frequency (%) |
| 20260211 | 1 | |
| 16329808 | 1 | |
| 5366099 | 1 | |
| 4826890 | 1 | |
| 3261756 | 1 | |
| 3076192 | 1 | |
| 2566420 | 1 | |
| 2423337 | 1 | |
| 2181628 | 1 | |
| 2135016 | 1 |
start_time
Date
| Distinct | 4117220 |
|---|---|
| Distinct (%) | 97.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 64.2 MiB |
| Minimum | 2015-09-21 14:53:16 |
|---|---|
| Maximum | 2023-12-31 23:59:57 |
Histogram with fixed size bins (bins=50)
stop_time
Date
| Distinct | 4118361 |
|---|---|
| Distinct (%) | 97.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 64.2 MiB |
| Minimum | 2015-09-21 14:54:17 |
|---|---|
| Maximum | 2024-01-01 23:12:00 |
Histogram with fixed size bins (bins=50)
start_station_id
Unsupported
REJECTED UNSUPPORTED
| Missing | 95 |
|---|---|
| Missing (%) | < 0.1% |
| Memory size | 239.0 MiB |
| Distinct | 369 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 95 |
| Missing (%) | < 0.1% |
| Memory size | 328.6 MiB |
Length
| Max length | 44 |
|---|---|
| Median length | 38 |
| Mean length | 16.877984 |
| Min length | 4 |
Characters and Unicode
| Total characters | 71020565 |
|---|---|
| Distinct characters | 66 |
| Distinct categories | 8 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 208 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Marin Light Rail |
|---|---|
| 2nd row | Exchange Place |
| 3rd row | Exchange Place |
| 4th row | McGinley Square |
| 5th row | Exchange Place |
| Value | Count | Frequency (%) |
| st | 2490687 | 16.7% |
| 1876230 | 12.6% | |
| ave | 496808 | 3.3% |
| park | 483465 | 3.2% |
| path | 434267 | 2.9% |
| grove | 298896 | 2.0% |
| hudson | 286197 | 1.9% |
| newport | 260171 | 1.7% |
| rail | 248972 | 1.7% |
| light | 248972 | 1.7% |
| Other values (361) | 7776735 |
Most occurring characters
| Value | Count | Frequency (%) |
| 10693520 | 15.1% | |
| t | 5132536 | 7.2% |
| r | 4226406 | 6.0% |
| a | 4208226 | 5.9% |
| e | 3817465 | 5.4% |
| o | 3609308 | 5.1% |
| n | 3600063 | 5.1% |
| S | 3102968 | 4.4% |
| i | 3084224 | 4.3% |
| l | 2469841 | 3.5% |
| Other values (56) | 27076008 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 43791344 | |
| Uppercase Letter | 13151483 | 18.5% |
| Space Separator | 10693520 | 15.1% |
| Decimal Number | 1507980 | 2.1% |
| Other Punctuation | 1346159 | 1.9% |
| Dash Punctuation | 530077 | 0.7% |
| Open Punctuation | 1 | < 0.1% |
| Close Punctuation | 1 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 5132536 | |
| r | 4226406 | |
| a | 4208226 | |
| e | 3817465 | 8.7% |
| o | 3609308 | 8.2% |
| n | 3600063 | 8.2% |
| i | 3084224 | 7.0% |
| l | 2469841 | 5.6% |
| s | 1870499 | 4.3% |
| k | 1372539 | 3.1% |
| Other values (15) | 10400237 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 3102968 | |
| H | 1557710 | |
| P | 1488032 | |
| A | 994412 | 7.6% |
| M | 720993 | 5.5% |
| C | 699216 | 5.3% |
| T | 631358 | 4.8% |
| L | 536903 | 4.1% |
| G | 536253 | 4.1% |
| W | 511345 | 3.9% |
| Other values (14) | 2372293 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 616037 | |
| 4 | 201647 | 13.4% |
| 6 | 197622 | 13.1% |
| 2 | 128546 | 8.5% |
| 5 | 83554 | 5.5% |
| 8 | 72844 | 4.8% |
| 9 | 64758 | 4.3% |
| 7 | 61192 | 4.1% |
| 3 | 57816 | 3.8% |
| 0 | 23964 | 1.6% |
Other Punctuation
| Value | Count | Frequency (%) |
| & | 1346157 | |
| ' | 1 | < 0.1% |
| . | 1 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 10693520 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 530077 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 1 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 56942827 | |
| Common | 14077738 | 19.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| t | 5132536 | 9.0% |
| r | 4226406 | 7.4% |
| a | 4208226 | 7.4% |
| e | 3817465 | 6.7% |
| o | 3609308 | 6.3% |
| n | 3600063 | 6.3% |
| S | 3102968 | 5.4% |
| i | 3084224 | 5.4% |
| l | 2469841 | 4.3% |
| s | 1870499 | 3.3% |
| Other values (39) | 21821291 |
Common
| Value | Count | Frequency (%) |
| 10693520 | ||
| & | 1346157 | 9.6% |
| 1 | 616037 | 4.4% |
| - | 530077 | 3.8% |
| 4 | 201647 | 1.4% |
| 6 | 197622 | 1.4% |
| 2 | 128546 | 0.9% |
| 5 | 83554 | 0.6% |
| 8 | 72844 | 0.5% |
| 9 | 64758 | 0.5% |
| Other values (7) | 142976 | 1.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 71020565 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 10693520 | 15.1% | |
| t | 5132536 | 7.2% |
| r | 4226406 | 6.0% |
| a | 4208226 | 5.9% |
| e | 3817465 | 5.4% |
| o | 3609308 | 5.1% |
| n | 3600063 | 5.1% |
| S | 3102968 | 4.4% |
| i | 3084224 | 4.3% |
| l | 2469841 | 3.5% |
| Other values (56) | 27076008 |
start_station_latitude
Real number (ℝ)
| Distinct | 128761 |
|---|---|
| Distinct (%) | 3.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 40.728049 |
| Minimum | 40.678334 |
|---|---|
| Maximum | 40.863943 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 64.2 MiB |
Quantile statistics
| Minimum | 40.678334 |
|---|---|
| 5-th percentile | 40.712774 |
| Q1 | 40.719252 |
| median | 40.725685 |
| Q3 | 40.736982 |
| 95-th percentile | 40.749985 |
| Maximum | 40.863943 |
| Range | 0.18560923 |
| Interquartile range (IQR) | 0.017730518 |
Descriptive statistics
| Standard deviation | 0.01143156 |
|---|---|
| Coefficient of variation (CV) | 0.00028068028 |
| Kurtosis | -0.64948803 |
| Mean | 40.728049 |
| Median Absolute Deviation (MAD) | 0.0079845164 |
| Skewness | 0.5750787 |
| Sum | 1.7138269 × 108 |
| Variance | 0.00013068057 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 40.71958612 | 239934 | 5.7% |
| 40.72759597 | 144046 | 3.4% |
| 40.7272235 | 120899 | 2.9% |
| 40.7287448 | 111351 | 2.6% |
| 40.71458404 | 92164 | 2.2% |
| 40.7192517 | 80268 | 1.9% |
| 40.7177325 | 79907 | 1.9% |
| 40.7211236 | 78827 | 1.9% |
| 40.7112423 | 78278 | 1.9% |
| 40.72152515 | 74426 | 1.8% |
| Other values (128751) | 3107877 |
| Value | Count | Frequency (%) |
| 40.67833407 | 1 | < 0.1% |
| 40.69187865 | 1 | < 0.1% |
| 40.69263997 | 317 | |
| 40.69531906 | 1 | < 0.1% |
| 40.6970299 | 520 | |
| 40.69865054 | 630 | |
| 40.69967915 | 1 | < 0.1% |
| 40.70068073 | 1 | < 0.1% |
| 40.70362493 | 1 | < 0.1% |
| 40.70452571 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 40.8639433 | 1 | < 0.1% |
| 40.8066187 | 1 | < 0.1% |
| 40.8028376 | 1 | < 0.1% |
| 40.79953315 | 1 | < 0.1% |
| 40.79118803 | 1 | < 0.1% |
| 40.78903018 | 9 | |
| 40.78179272 | 1 | < 0.1% |
| 40.78096507 | 1 | < 0.1% |
| 40.77986812 | 2 | < 0.1% |
| 40.77917727 | 1 | < 0.1% |
start_station_longitude
Real number (ℝ)
| Distinct | 136915 |
|---|---|
| Distinct (%) | 3.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -74.042837 |
| Minimum | -74.096937 |
|---|---|
| Maximum | -73.941173 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 4207977 |
| Negative (%) | 100.0% |
| Memory size | 64.2 MiB |
Quantile statistics
| Minimum | -74.096937 |
|---|---|
| 5-th percentile | -74.067537 |
| Q1 | -74.04879 |
| median | -74.042817 |
| Q3 | -74.033552 |
| 95-th percentile | -74.027781 |
| Maximum | -73.941173 |
| Range | 0.1557632 |
| Interquartile range (IQR) | 0.015238436 |
Descriptive statistics
| Standard deviation | 0.01205685 |
|---|---|
| Coefficient of variation (CV) | -0.00016283615 |
| Kurtosis | 0.5314823 |
| Mean | -74.042837 |
| Median Absolute Deviation (MAD) | 0.0081729438 |
| Skewness | -0.92699455 |
| Sum | -3.1157056 × 108 |
| Variance | 0.00014536764 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -74.04311746 | 239934 | 5.7% |
| -74.04424731 | 144046 | 3.4% |
| -74.0337589 | 120899 | 2.9% |
| -74.0321082 | 111351 | 2.6% |
| -74.04281706 | 92164 | 2.2% |
| -74.034234 | 84417 | 2.0% |
| -74.043845 | 83397 | 2.0% |
| -74.03805095 | 78827 | 1.9% |
| -74.0557013 | 78278 | 1.9% |
| -74.04630454 | 74426 | 1.8% |
| Other values (136905) | 3100238 |
| Value | Count | Frequency (%) |
| -74.0969366 | 520 | |
| -74.08896387 | 2 | < 0.1% |
| -74.0887723 | 717 | |
| -74.08801228 | 317 | |
| -74.08722293 | 1 | < 0.1% |
| -74.08714485 | 1 | < 0.1% |
| -74.08706903 | 1 | < 0.1% |
| -74.0868541 | 1 | < 0.1% |
| -74.08684921 | 1 | < 0.1% |
| -74.08684228 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| -73.9411734 | 1 | < 0.1% |
| -73.99727857 | 1 | < 0.1% |
| -73.99793313 | 9 | |
| -73.99886102 | 1 | < 0.1% |
| -74.00098978 | 2 | < 0.1% |
| -74.00336778 | 1 | < 0.1% |
| -74.00455577 | 1 | < 0.1% |
| -74.00700725 | 1 | < 0.1% |
| -74.00907335 | 1 | < 0.1% |
| -74.01260012 | 4 |
end_station_id
Unsupported
REJECTED UNSUPPORTED
| Missing | 10023 |
|---|---|
| Missing (%) | 0.2% |
| Memory size | 238.7 MiB |
end_station_name
Text
| Distinct | 752 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 10023 |
| Missing (%) | 0.2% |
| Memory size | 328.4 MiB |
Length
| Max length | 55 |
|---|---|
| Median length | 40 |
| Mean length | 16.925813 |
| Min length | 4 |
Characters and Unicode
| Total characters | 71053785 |
|---|---|
| Distinct characters | 69 |
| Distinct categories | 9 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 249 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | City Hall |
|---|---|
| 2nd row | Heights Elevator |
| 3rd row | Newark Ave |
| 4th row | Danforth Light Rail |
| 5th row | Hamilton Park |
| Value | Count | Frequency (%) |
| st | 2546618 | 17.0% |
| 1871933 | 12.5% | |
| path | 490382 | 3.3% |
| park | 473715 | 3.2% |
| ave | 471382 | 3.2% |
| grove | 352490 | 2.4% |
| hudson | 285560 | 1.9% |
| newport | 262625 | 1.8% |
| rail | 252313 | 1.7% |
| light | 252313 | 1.7% |
| Other values (548) | 7701491 |
Most occurring characters
| Value | Count | Frequency (%) |
| 10762885 | 15.1% | |
| t | 5162173 | 7.3% |
| r | 4192042 | 5.9% |
| a | 4174103 | 5.9% |
| e | 3817832 | 5.4% |
| o | 3622544 | 5.1% |
| n | 3557476 | 5.0% |
| S | 3138965 | 4.4% |
| i | 3018923 | 4.2% |
| l | 2437399 | 3.4% |
| Other values (59) | 27169443 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 43527447 | |
| Uppercase Letter | 13386882 | 18.8% |
| Space Separator | 10762885 | 15.1% |
| Decimal Number | 1503180 | 2.1% |
| Other Punctuation | 1341569 | 1.9% |
| Dash Punctuation | 531787 | 0.7% |
| Open Punctuation | 17 | < 0.1% |
| Close Punctuation | 17 | < 0.1% |
| Connector Punctuation | 1 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 5162173 | |
| r | 4192042 | |
| a | 4174103 | |
| e | 3817832 | 8.8% |
| o | 3622544 | 8.3% |
| n | 3557476 | 8.2% |
| i | 3018923 | 6.9% |
| l | 2437399 | 5.6% |
| s | 1835305 | 4.2% |
| k | 1349348 | 3.1% |
| Other values (15) | 10360302 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 3138965 | |
| H | 1600574 | |
| P | 1550870 | |
| A | 1025662 | 7.7% |
| M | 698645 | 5.2% |
| C | 696110 | 5.2% |
| T | 686506 | 5.1% |
| G | 571738 | 4.3% |
| L | 543619 | 4.1% |
| W | 516189 | 3.9% |
| Other values (15) | 2358004 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 624688 | |
| 4 | 203863 | 13.6% |
| 6 | 183433 | 12.2% |
| 2 | 130169 | 8.7% |
| 5 | 80346 | 5.3% |
| 8 | 72382 | 4.8% |
| 9 | 65460 | 4.4% |
| 7 | 61894 | 4.1% |
| 3 | 55366 | 3.7% |
| 0 | 25579 | 1.7% |
Other Punctuation
| Value | Count | Frequency (%) |
| & | 1340167 | |
| ' | 1384 | 0.1% |
| \ | 17 | < 0.1% |
| . | 1 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 10762885 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 531787 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 17 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 17 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 56914329 | |
| Common | 14139456 | 19.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| t | 5162173 | 9.1% |
| r | 4192042 | 7.4% |
| a | 4174103 | 7.3% |
| e | 3817832 | 6.7% |
| o | 3622544 | 6.4% |
| n | 3557476 | 6.3% |
| S | 3138965 | 5.5% |
| i | 3018923 | 5.3% |
| l | 2437399 | 4.3% |
| s | 1835305 | 3.2% |
| Other values (40) | 21957567 |
Common
| Value | Count | Frequency (%) |
| 10762885 | ||
| & | 1340167 | 9.5% |
| 1 | 624688 | 4.4% |
| - | 531787 | 3.8% |
| 4 | 203863 | 1.4% |
| 6 | 183433 | 1.3% |
| 2 | 130169 | 0.9% |
| 5 | 80346 | 0.6% |
| 8 | 72382 | 0.5% |
| 9 | 65460 | 0.5% |
| Other values (9) | 144276 | 1.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 71053785 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 10762885 | 15.1% | |
| t | 5162173 | 7.3% |
| r | 4192042 | 5.9% |
| a | 4174103 | 5.9% |
| e | 3817832 | 5.4% |
| o | 3622544 | 5.1% |
| n | 3557476 | 5.0% |
| S | 3138965 | 4.4% |
| i | 3018923 | 4.2% |
| l | 2437399 | 3.4% |
| Other values (59) | 27169443 |
end_station_latitude
Real number (ℝ)
SKEWED
| Distinct | 867 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 5156 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 40.720227 |
| Minimum | 0 |
|---|---|
| Maximum | 40.872412 |
| Zeros | 787 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 64.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 40.712774 |
| Q1 | 40.719252 |
| median | 40.72534 |
| Q3 | 40.736068 |
| 95-th percentile | 40.749985 |
| Maximum | 40.872412 |
| Range | 40.872412 |
| Interquartile range (IQR) | 0.016815956 |
Descriptive statistics
| Standard deviation | 0.55739221 |
|---|---|
| Coefficient of variation (CV) | 0.013688337 |
| Kurtosis | 5330.7391 |
| Mean | 40.720227 |
| Median Absolute Deviation (MAD) | 0.0076074254 |
| Skewness | -73.009925 |
| Sum | 1.7113983 × 108 |
| Variance | 0.31068607 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 40.71958612 | 299334 | 7.1% |
| 40.72759597 | 153663 | 3.7% |
| 40.7272235 | 137393 | 3.3% |
| 40.7287448 | 123975 | 2.9% |
| 40.71458404 | 101681 | 2.4% |
| 40.7177325 | 92844 | 2.2% |
| 40.73606766 | 92298 | 2.2% |
| 40.7112423 | 91751 | 2.2% |
| 40.73698222 | 91245 | 2.2% |
| 40.7192517 | 89750 | 2.1% |
| Other values (857) | 2928887 |
| Value | Count | Frequency (%) |
| 0 | 787 | |
| 40.64 | 1 | < 0.1% |
| 40.64507 | 1 | < 0.1% |
| 40.64621 | 1 | < 0.1% |
| 40.646377 | 1 | < 0.1% |
| 40.649292 | 1 | < 0.1% |
| 40.64958 | 1 | < 0.1% |
| 40.65 | 4 | < 0.1% |
| 40.66 | 3 | < 0.1% |
| 40.6630619 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 40.872412 | 1 | < 0.1% |
| 40.86448 | 1 | < 0.1% |
| 40.863124 | 1 | < 0.1% |
| 40.86156 | 1 | < 0.1% |
| 40.861382 | 1 | < 0.1% |
| 40.852252 | 1 | < 0.1% |
| 40.85168 | 7 | < 0.1% |
| 40.85 | 2 | < 0.1% |
| 40.849972 | 21 | |
| 40.848467 | 1 | < 0.1% |
end_station_longitude
Real number (ℝ)
SKEWED
| Distinct | 870 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 5156 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -74.028609 |
| Minimum | -74.19 |
|---|---|
| Maximum | 0 |
| Zeros | 787 |
| Zeros (%) | < 0.1% |
| Negative | 4202034 |
| Negative (%) | 99.9% |
| Memory size | 64.2 MiB |
Quantile statistics
| Minimum | -74.19 |
|---|---|
| 5-th percentile | -74.066921 |
| Q1 | -74.047727 |
| median | -74.042817 |
| Q3 | -74.033552 |
| 95-th percentile | -74.027781 |
| Maximum | 0 |
| Range | 74.19 |
| Interquartile range (IQR) | 0.014174725 |
Descriptive statistics
| Standard deviation | 1.0131829 |
|---|---|
| Coefficient of variation (CV) | -0.013686369 |
| Kurtosis | 5333.808 |
| Mean | -74.028609 |
| Median Absolute Deviation (MAD) | 0.0081729438 |
| Skewness | 73.041444 |
| Sum | -3.1112899 × 108 |
| Variance | 1.0265395 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -74.04311746 | 299334 | 7.1% |
| -74.04424731 | 153663 | 3.7% |
| -74.0337589 | 137393 | 3.3% |
| -74.0321082 | 123975 | 2.9% |
| -74.04281706 | 101681 | 2.4% |
| -74.043845 | 93325 | 2.2% |
| -74.02912706 | 92298 | 2.2% |
| -74.0557013 | 91751 | 2.2% |
| -74.02778059 | 91245 | 2.2% |
| -74.034234 | 90283 | 2.1% |
| Other values (860) | 2927873 |
| Value | Count | Frequency (%) |
| -74.19 | 1 | < 0.1% |
| -74.18 | 1 | < 0.1% |
| -74.16 | 3 | < 0.1% |
| -74.15 | 4 | < 0.1% |
| -74.14 | 4 | < 0.1% |
| -74.13 | 1 | < 0.1% |
| -74.12 | 6 | < 0.1% |
| -74.11 | 20 | < 0.1% |
| -74.1 | 42 | < 0.1% |
| -74.0969366 | 568 |
| Value | Count | Frequency (%) |
| 0 | 787 | |
| -73.888271 | 1 | < 0.1% |
| -73.888719 | 1 | < 0.1% |
| -73.89 | 1 | < 0.1% |
| -73.89081 | 2 | < 0.1% |
| -73.891677 | 1 | < 0.1% |
| -73.892103 | 1 | < 0.1% |
| -73.89522 | 1 | < 0.1% |
| -73.896599 | 2 | < 0.1% |
| -73.89795 | 1 | < 0.1% |
bike_id
Real number (ℝ)
MISSING
| Distinct | 3116 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 2517155 |
| Missing (%) | 59.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 30547.503 |
| Minimum | 14529 |
|---|---|
| Maximum | 49985 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 64.2 MiB |
Quantile statistics
| Minimum | 14529 |
|---|---|
| 5-th percentile | 24475 |
| Q1 | 26220 |
| median | 29302 |
| Q3 | 31710 |
| 95-th percentile | 44225 |
| Maximum | 49985 |
| Range | 35456 |
| Interquartile range (IQR) | 5490 |
Descriptive statistics
| Standard deviation | 6280.7493 |
|---|---|
| Coefficient of variation (CV) | 0.20560598 |
| Kurtosis | 0.32846665 |
| Mean | 30547.503 |
| Median Absolute Deviation (MAD) | 3054 |
| Skewness | 1.1727291 |
| Sum | 5.1650391 × 1010 |
| Variance | 39447812 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 26159 | 2704 | 0.1% |
| 26260 | 2694 | 0.1% |
| 26170 | 2678 | 0.1% |
| 26236 | 2675 | 0.1% |
| 26161 | 2674 | 0.1% |
| 26306 | 2667 | 0.1% |
| 26431 | 2658 | 0.1% |
| 26192 | 2638 | 0.1% |
| 26213 | 2628 | 0.1% |
| 26286 | 2617 | 0.1% |
| Other values (3106) | 1664189 | |
| (Missing) | 2517155 |
| Value | Count | Frequency (%) |
| 14529 | 3 | < 0.1% |
| 14531 | 45 | < 0.1% |
| 14536 | 20 | < 0.1% |
| 14552 | 10 | < 0.1% |
| 14556 | 34 | < 0.1% |
| 14578 | 3 | < 0.1% |
| 14585 | 104 | |
| 14598 | 59 | < 0.1% |
| 14607 | 178 | |
| 14632 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 49985 | 6 | < 0.1% |
| 49734 | 3 | < 0.1% |
| 49527 | 14 | < 0.1% |
| 49081 | 20 | < 0.1% |
| 49058 | 5 | < 0.1% |
| 48932 | 96 | |
| 48930 | 63 | |
| 48929 | 61 | |
| 48924 | 92 | |
| 48923 | 68 |
user_type
Categorical
MISSING
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2517652 |
| Missing (%) | 59.8% |
| Memory size | 274.2 MiB |
| Subscriber | |
|---|---|
| Customer |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 9.7528298 |
| Min length | 8 |
Characters and Unicode
| Total characters | 16485452 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Subscriber |
|---|---|
| 2nd row | Subscriber |
| 3rd row | Subscriber |
| 4th row | Subscriber |
| 5th row | Subscriber |
Common Values
| Value | Count | Frequency (%) |
| Subscriber | 1481426 | |
| Customer | 208899 | 5.0% |
| (Missing) | 2517652 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| subscriber | 1481426 | |
| customer | 208899 | 12.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 3171751 | |
| b | 2962852 | |
| s | 1690325 | |
| u | 1690325 | |
| e | 1690325 | |
| S | 1481426 | |
| c | 1481426 | |
| i | 1481426 | |
| C | 208899 | 1.3% |
| t | 208899 | 1.3% |
| Other values (2) | 417798 | 2.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 14795127 | |
| Uppercase Letter | 1690325 | 10.3% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| r | 3171751 | |
| b | 2962852 | |
| s | 1690325 | |
| u | 1690325 | |
| e | 1690325 | |
| c | 1481426 | |
| i | 1481426 | |
| t | 208899 | 1.4% |
| o | 208899 | 1.4% |
| m | 208899 | 1.4% |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 1481426 | |
| C | 208899 | 12.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 16485452 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| r | 3171751 | |
| b | 2962852 | |
| s | 1690325 | |
| u | 1690325 | |
| e | 1690325 | |
| S | 1481426 | |
| c | 1481426 | |
| i | 1481426 | |
| C | 208899 | 1.3% |
| t | 208899 | 1.3% |
| Other values (2) | 417798 | 2.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 16485452 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| r | 3171751 | |
| b | 2962852 | |
| s | 1690325 | |
| u | 1690325 | |
| e | 1690325 | |
| S | 1481426 | |
| c | 1481426 | |
| i | 1481426 | |
| C | 208899 | 1.3% |
| t | 208899 | 1.3% |
| Other values (2) | 417798 | 2.5% |
birth_year
Real number (ℝ)
MISSING
| Distinct | 82 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2560677 |
| Missing (%) | 60.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1980.5658 |
| Minimum | 1887 |
|---|---|
| Maximum | 2004 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 64.2 MiB |
Quantile statistics
| Minimum | 1887 |
|---|---|
| 5-th percentile | 1960 |
| Q1 | 1974 |
| median | 1983 |
| Q3 | 1988 |
| 95-th percentile | 1994 |
| Maximum | 2004 |
| Range | 117 |
| Interquartile range (IQR) | 14 |
Descriptive statistics
| Standard deviation | 10.347948 |
|---|---|
| Coefficient of variation (CV) | 0.0052247435 |
| Kurtosis | 1.402828 |
| Mean | 1980.5658 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | -0.87854412 |
| Sum | 3.262586 × 109 |
| Variance | 107.08003 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1969 | 110638 | 2.6% |
| 1989 | 84411 | 2.0% |
| 1986 | 83332 | 2.0% |
| 1988 | 82271 | 2.0% |
| 1987 | 75599 | 1.8% |
| 1984 | 72789 | 1.7% |
| 1990 | 71698 | 1.7% |
| 1983 | 66868 | 1.6% |
| 1985 | 64856 | 1.5% |
| 1981 | 63137 | 1.5% |
| Other values (72) | 871701 | 20.7% |
| (Missing) | 2560677 |
| Value | Count | Frequency (%) |
| 1887 | 71 | < 0.1% |
| 1888 | 260 | |
| 1889 | 4 | < 0.1% |
| 1900 | 65 | < 0.1% |
| 1901 | 1 | < 0.1% |
| 1904 | 19 | < 0.1% |
| 1905 | 1 | < 0.1% |
| 1918 | 2 | < 0.1% |
| 1920 | 1 | < 0.1% |
| 1923 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 2004 | 26 | < 0.1% |
| 2003 | 291 | < 0.1% |
| 2002 | 677 | < 0.1% |
| 2001 | 1490 | < 0.1% |
| 2000 | 2788 | 0.1% |
| 1999 | 2873 | 0.1% |
| 1998 | 5880 | 0.1% |
| 1997 | 7879 | 0.2% |
| 1996 | 16611 | |
| 1995 | 20766 |
gender
Categorical
MISSING
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2517155 |
| Missing (%) | 59.8% |
| Memory size | 263.3 MiB |
| 1.0 | |
|---|---|
| 2.0 | |
| 0.0 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 5072466 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1.0 |
|---|---|
| 2nd row | 1.0 |
| 3rd row | 1.0 |
| 4th row | 1.0 |
| 5th row | 1.0 |
Common Values
| Value | Count | Frequency (%) |
| 1.0 | 1168398 | |
| 2.0 | 375403 | 8.9% |
| 0.0 | 147021 | 3.5% |
| (Missing) | 2517155 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1.0 | 1168398 | |
| 2.0 | 375403 | 22.2% |
| 0.0 | 147021 | 8.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1837843 | |
| . | 1690822 | |
| 1 | 1168398 | |
| 2 | 375403 | 7.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 3381644 | |
| Other Punctuation | 1690822 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 1837843 | |
| 1 | 1168398 | |
| 2 | 375403 | 11.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 1690822 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 5072466 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 1837843 | |
| . | 1690822 | |
| 1 | 1168398 | |
| 2 | 375403 | 7.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5072466 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 1837843 | |
| . | 1690822 | |
| 1 | 1168398 | |
| 2 | 375403 | 7.4% |
ride_id
Text
MISSING
| Distinct | 2517155 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 1690822 |
| Missing (%) | 40.2% |
| Memory size | 258.9 MiB |
Length
| Max length | 16 |
|---|---|
| Median length | 16 |
| Mean length | 16 |
| Min length | 16 |
Characters and Unicode
| Total characters | 40274480 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 2517155 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | 74A4206E7487CBC9 |
|---|---|
| 2nd row | 58EEE2950FFE01CE |
| 3rd row | 1429D912C16EEE59 |
| 4th row | FE9C5B74167CBCCD |
| 5th row | B88D37626F000BBA |
| Value | Count | Frequency (%) |
| ba95401d75622ccb | 1 | < 0.1% |
| f71732ece7cd02cf | 1 | < 0.1% |
| d4b9012b427b1ba8 | 1 | < 0.1% |
| 2a99fcafc6b1c7ce | 1 | < 0.1% |
| b31e3625915a88e1 | 1 | < 0.1% |
| e0b99a4aaca77034 | 1 | < 0.1% |
| bd52c7872af620e6 | 1 | < 0.1% |
| 20bd42adad2ca6a0 | 1 | < 0.1% |
| 23467b6f12bca65b | 1 | < 0.1% |
| cd4d1af21695161a | 1 | < 0.1% |
| Other values (2517145) | 2517145 |
Most occurring characters
| Value | Count | Frequency (%) |
| 8 | 2519031 | 6.3% |
| 3 | 2519025 | 6.3% |
| 2 | 2518483 | 6.3% |
| 5 | 2518448 | 6.3% |
| A | 2518241 | 6.3% |
| 1 | 2517494 | 6.3% |
| D | 2517478 | 6.3% |
| B | 2517225 | 6.3% |
| F | 2517212 | 6.3% |
| E | 2517109 | 6.2% |
| Other values (6) | 15094734 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 25171441 | |
| Uppercase Letter | 15103039 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 8 | 2519031 | |
| 3 | 2519025 | |
| 2 | 2518483 | |
| 5 | 2518448 | |
| 1 | 2517494 | |
| 7 | 2516992 | |
| 9 | 2515879 | |
| 4 | 2515838 | |
| 0 | 2515428 | |
| 6 | 2514823 |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 2518241 | |
| D | 2517478 | |
| B | 2517225 | |
| F | 2517212 | |
| E | 2517109 | |
| C | 2515774 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 25171441 | |
| Latin | 15103039 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 8 | 2519031 | |
| 3 | 2519025 | |
| 2 | 2518483 | |
| 5 | 2518448 | |
| 1 | 2517494 | |
| 7 | 2516992 | |
| 9 | 2515879 | |
| 4 | 2515838 | |
| 0 | 2515428 | |
| 6 | 2514823 |
Latin
| Value | Count | Frequency (%) |
| A | 2518241 | |
| D | 2517478 | |
| B | 2517225 | |
| F | 2517212 | |
| E | 2517109 | |
| C | 2515774 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 40274480 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 8 | 2519031 | 6.3% |
| 3 | 2519025 | 6.3% |
| 2 | 2518483 | 6.3% |
| 5 | 2518448 | 6.3% |
| A | 2518241 | 6.3% |
| 1 | 2517494 | 6.3% |
| D | 2517478 | 6.3% |
| B | 2517225 | 6.3% |
| F | 2517212 | 6.3% |
| E | 2517109 | 6.2% |
| Other values (6) | 15094734 |
rideable_type
Categorical
MISSING
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1690822 |
| Missing (%) | 40.2% |
| Memory size | 288.4 MiB |
| classic_bike | |
|---|---|
| electric_bike | |
| docked_bike | 142574 |
Length
| Max length | 13 |
|---|---|
| Median length | 12 |
| Mean length | 12.153163 |
| Min length | 11 |
Characters and Unicode
| Total characters | 30591394 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | docked_bike |
|---|---|
| 2nd row | docked_bike |
| 3rd row | docked_bike |
| 4th row | docked_bike |
| 5th row | docked_bike |
Common Values
| Value | Count | Frequency (%) |
| classic_bike | 1846473 | |
| electric_bike | 528108 | 12.6% |
| docked_bike | 142574 | 3.4% |
| (Missing) | 1690822 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| classic_bike | 1846473 | |
| electric_bike | 528108 | 21.0% |
| docked_bike | 142574 | 5.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| c | 4891736 | |
| i | 4891736 | |
| e | 3715945 | |
| s | 3692946 | |
| k | 2659729 | |
| b | 2517155 | |
| _ | 2517155 | |
| l | 2374581 | |
| a | 1846473 | 6.0% |
| t | 528108 | 1.7% |
| Other values (3) | 955830 | 3.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 28074239 | |
| Connector Punctuation | 2517155 | 8.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| c | 4891736 | |
| i | 4891736 | |
| e | 3715945 | |
| s | 3692946 | |
| k | 2659729 | |
| b | 2517155 | |
| l | 2374581 | |
| a | 1846473 | 6.6% |
| t | 528108 | 1.9% |
| r | 528108 | 1.9% |
| Other values (2) | 427722 | 1.5% |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 2517155 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 28074239 | |
| Common | 2517155 | 8.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| c | 4891736 | |
| i | 4891736 | |
| e | 3715945 | |
| s | 3692946 | |
| k | 2659729 | |
| b | 2517155 | |
| l | 2374581 | |
| a | 1846473 | 6.6% |
| t | 528108 | 1.9% |
| r | 528108 | 1.9% |
| Other values (2) | 427722 | 1.5% |
Common
| Value | Count | Frequency (%) |
| _ | 2517155 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 30591394 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| c | 4891736 | |
| i | 4891736 | |
| e | 3715945 | |
| s | 3692946 | |
| k | 2659729 | |
| b | 2517155 | |
| _ | 2517155 | |
| l | 2374581 | |
| a | 1846473 | 6.0% |
| t | 528108 | 1.7% |
| Other values (3) | 955830 | 3.1% |
member_casual
Categorical
MISSING
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1690822 |
| Missing (%) | 40.2% |
| Memory size | 273.6 MiB |
| member | |
|---|---|
| casual |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 6 |
| Min length | 6 |
Characters and Unicode
| Total characters | 15102930 |
|---|---|
| Distinct characters | 9 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | casual |
|---|---|
| 2nd row | member |
| 3rd row | casual |
| 4th row | casual |
| 5th row | casual |
Common Values
| Value | Count | Frequency (%) |
| member | 1694959 | |
| casual | 822196 | |
| (Missing) | 1690822 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| member | 1694959 | |
| casual | 822196 |
Most occurring characters
| Value | Count | Frequency (%) |
| m | 3389918 | |
| e | 3389918 | |
| b | 1694959 | |
| r | 1694959 | |
| a | 1644392 | |
| c | 822196 | 5.4% |
| s | 822196 | 5.4% |
| u | 822196 | 5.4% |
| l | 822196 | 5.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 15102930 |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| m | 3389918 | |
| e | 3389918 | |
| b | 1694959 | |
| r | 1694959 | |
| a | 1644392 | |
| c | 822196 | 5.4% |
| s | 822196 | 5.4% |
| u | 822196 | 5.4% |
| l | 822196 | 5.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 15102930 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| m | 3389918 | |
| e | 3389918 | |
| b | 1694959 | |
| r | 1694959 | |
| a | 1644392 | |
| c | 822196 | 5.4% |
| s | 822196 | 5.4% |
| u | 822196 | 5.4% |
| l | 822196 | 5.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 15102930 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| m | 3389918 | |
| e | 3389918 | |
| b | 1694959 | |
| r | 1694959 | |
| a | 1644392 | |
| c | 822196 | 5.4% |
| s | 822196 | 5.4% |
| u | 822196 | 5.4% |
| l | 822196 | 5.4% |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
| trip_duration | start_time | stop_time | start_station_id | start_station_name | start_station_latitude | start_station_longitude | end_station_id | end_station_name | end_station_latitude | end_station_longitude | bike_id | user_type | birth_year | gender | ride_id | rideable_type | member_casual | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 148.0 | 2017-01-01 00:21:32 | 2017-01-01 00:24:01 | 3276 | Marin Light Rail | 40.714584 | -74.042817 | 3185 | City Hall | 40.717732 | -74.043845 | 24575.0 | Subscriber | 1983.0 | 1.0 | NaN | NaN | NaN |
| 1 | 1283.0 | 2017-01-01 00:24:35 | 2017-01-01 00:45:58 | 3183 | Exchange Place | 40.716247 | -74.033459 | 3198 | Heights Elevator | 40.748716 | -74.040443 | 24723.0 | Subscriber | 1978.0 | 1.0 | NaN | NaN | NaN |
| 2 | 372.0 | 2017-01-01 00:38:19 | 2017-01-01 00:44:31 | 3183 | Exchange Place | 40.716247 | -74.033459 | 3211 | Newark Ave | 40.721525 | -74.046305 | 24620.0 | Subscriber | 1989.0 | 1.0 | NaN | NaN | NaN |
| 3 | 1513.0 | 2017-01-01 00:38:37 | 2017-01-01 01:03:50 | 3194 | McGinley Square | 40.725340 | -74.067622 | 3271 | Danforth Light Rail | 40.692640 | -74.088012 | 24668.0 | Subscriber | 1961.0 | 1.0 | NaN | NaN | NaN |
| 4 | 639.0 | 2017-01-01 01:47:52 | 2017-01-01 01:58:31 | 3183 | Exchange Place | 40.716247 | -74.033459 | 3203 | Hamilton Park | 40.727596 | -74.044247 | 26167.0 | Subscriber | 1993.0 | 1.0 | NaN | NaN | NaN |
| 5 | 258.0 | 2017-01-01 01:56:29 | 2017-01-01 02:00:48 | 3186 | Grove St PATH | 40.719586 | -74.043117 | 3270 | Jersey & 6th St | 40.725289 | -74.045572 | 24604.0 | Subscriber | 1970.0 | 1.0 | NaN | NaN | NaN |
| 6 | 663.0 | 2017-01-01 02:12:34 | 2017-01-01 02:23:38 | 3270 | Jersey & 6th St | 40.725289 | -74.045572 | 3206 | Hilltop | 40.731169 | -74.057574 | 24641.0 | Subscriber | 1978.0 | 1.0 | NaN | NaN | NaN |
| 7 | 567.0 | 2017-01-01 02:15:52 | 2017-01-01 02:25:20 | 3192 | Liberty Light Rail | 40.711242 | -74.055701 | 3213 | Van Vorst Park | 40.718489 | -74.047727 | 24513.0 | Subscriber | 1970.0 | 1.0 | NaN | NaN | NaN |
| 8 | 551.0 | 2017-01-01 02:16:03 | 2017-01-01 02:25:15 | 3192 | Liberty Light Rail | 40.711242 | -74.055701 | 3213 | Van Vorst Park | 40.718489 | -74.047727 | 24463.0 | Subscriber | 1967.0 | 2.0 | NaN | NaN | NaN |
| 9 | 573.0 | 2017-01-01 02:22:17 | 2017-01-01 02:31:50 | 3212 | Christ Hospital | 40.734786 | -74.050444 | 3225 | Baldwin at Montgomery | 40.723659 | -74.064194 | 24486.0 | Subscriber | 1984.0 | 1.0 | NaN | NaN | NaN |
| trip_duration | start_time | stop_time | start_station_id | start_station_name | start_station_latitude | start_station_longitude | end_station_id | end_station_name | end_station_latitude | end_station_longitude | bike_id | user_type | birth_year | gender | ride_id | rideable_type | member_casual | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 53823 | 76.0 | 2020-10-13 14:58:27.7520 | 2020-10-13 14:59:44.4970 | 3185 | City Hall | 40.717732 | -74.043845 | 3185 | City Hall | 40.717732 | -74.043845 | 44737.0 | Subscriber | 1976.0 | 1.0 | NaN | NaN | NaN |
| 53824 | 305.0 | 2020-10-13 15:00:09.3240 | 2020-10-13 15:05:15.1470 | 3186 | Grove St PATH | 40.719586 | -74.043117 | 3203 | Hamilton Park | 40.727596 | -74.044247 | 42213.0 | Subscriber | 1996.0 | 1.0 | NaN | NaN | NaN |
| 53825 | 99.0 | 2020-10-13 15:00:35.9260 | 2020-10-13 15:02:15.3180 | 3185 | City Hall | 40.717732 | -74.043845 | 3185 | City Hall | 40.717732 | -74.043845 | 44347.0 | Subscriber | 1976.0 | 1.0 | NaN | NaN | NaN |
| 53826 | 492.0 | 2020-10-13 15:03:05.3220 | 2020-10-13 15:11:18.0610 | 3195 | Sip Ave | 40.730897 | -74.063913 | 3225 | Baldwin at Montgomery | 40.723659 | -74.064194 | 46598.0 | Customer | 1998.0 | 1.0 | NaN | NaN | NaN |
| 53827 | 715.0 | 2020-10-13 15:04:16.8400 | 2020-10-13 15:16:12.3870 | 3185 | City Hall | 40.717732 | -74.043845 | 3269 | Brunswick & 6th | 40.726012 | -74.050389 | 44737.0 | Subscriber | 1976.0 | 1.0 | NaN | NaN | NaN |
| 53828 | 270.0 | 2020-10-13 15:05:35.0860 | 2020-10-13 15:10:05.3430 | 3207 | Oakland Ave | 40.737604 | -74.052478 | 3640 | Journal Square | 40.733670 | -74.062500 | 44744.0 | Subscriber | 1963.0 | 2.0 | NaN | NaN | NaN |
| 53829 | 400.0 | 2020-10-13 15:09:03.4890 | 2020-10-13 15:15:43.9750 | 3209 | Brunswick St | 40.724176 | -74.050656 | 3209 | Brunswick St | 40.724176 | -74.050656 | 45345.0 | Subscriber | 1984.0 | 1.0 | NaN | NaN | NaN |
| 53830 | 206.0 | 2020-10-13 15:11:34.3500 | 2020-10-13 15:15:00.5030 | 3195 | Sip Ave | 40.730897 | -74.063913 | 3194 | McGinley Square | 40.725340 | -74.067622 | 47019.0 | Subscriber | 1993.0 | 1.0 | NaN | NaN | NaN |
| 53831 | 216.0 | 2020-10-13 15:11:49.1510 | 2020-10-13 15:15:25.6930 | 3195 | Sip Ave | 40.730897 | -74.063913 | 3225 | Baldwin at Montgomery | 40.723659 | -74.064194 | 42191.0 | Subscriber | 1966.0 | 1.0 | NaN | NaN | NaN |
| 53832 | 418.0 | 2020-10-13 15:12:31.7920 | 2020-10-13 15:19:30.5280 | 3267 | Morris Canal | 40.712419 | -74.038526 | 3186 | Grove St PATH | 40.719586 | -74.043117 | 47255.0 | Subscriber | 1991.0 | 1.0 | NaN | NaN | NaN |
Most frequently occurring
| trip_duration | start_time | stop_time | start_station_name | start_station_latitude | start_station_longitude | end_station_name | end_station_latitude | end_station_longitude | bike_id | user_type | birth_year | gender | ride_id | rideable_type | member_casual | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 61.0 | 2020-10-07 14:59:28.8250 | 2020-10-07 15:00:30.2640 | Sip Ave | 40.730897 | -74.063913 | Sip Ave | 40.730897 | -74.063913 | 42535.0 | Subscriber | 1977.0 | 2.0 | NaN | NaN | NaN | 2 |
| 1 | 61.0 | 2020-10-08 16:56:51.9260 | 2020-10-08 16:57:53.2300 | Brunswick & 6th | 40.726012 | -74.050389 | Brunswick St | 40.724176 | -74.050656 | 33887.0 | Subscriber | 1987.0 | 1.0 | NaN | NaN | NaN | 2 |
| 2 | 62.0 | 2020-10-04 11:39:28.5210 | 2020-10-04 11:40:31.3950 | Warren St | 40.721124 | -74.038051 | Warren St | 40.721124 | -74.038051 | 42195.0 | Subscriber | 1970.0 | 2.0 | NaN | NaN | NaN | 2 |
| 3 | 62.0 | 2020-10-05 18:18:44.0370 | 2020-10-05 18:19:46.3250 | Jersey & 6th St | 40.725289 | -74.045572 | Jersey & 3rd | 40.723332 | -74.045953 | 33859.0 | Subscriber | 1977.0 | 1.0 | NaN | NaN | NaN | 2 |
| 4 | 62.0 | 2020-10-08 12:25:14.0660 | 2020-10-08 12:26:16.5070 | City Hall | 40.717732 | -74.043845 | City Hall | 40.717732 | -74.043845 | 33859.0 | Subscriber | 1972.0 | 1.0 | NaN | NaN | NaN | 2 |
| 5 | 63.0 | 2020-10-07 19:00:46.0890 | 2020-10-07 19:01:49.2280 | Newport Pkwy | 40.728745 | -74.032108 | Newport Pkwy | 40.728745 | -74.032108 | 42460.0 | Subscriber | 1986.0 | 1.0 | NaN | NaN | NaN | 2 |
| 6 | 64.0 | 2020-10-12 20:41:50.8680 | 2020-10-12 20:42:55.3970 | Warren St | 40.721124 | -74.038051 | Warren St | 40.721124 | -74.038051 | 44687.0 | Customer | 1987.0 | 1.0 | NaN | NaN | NaN | 2 |
| 7 | 66.0 | 2020-10-04 19:07:55.7000 | 2020-10-04 19:09:02.2950 | Monmouth and 6th | 40.725685 | -74.048790 | Monmouth and 6th | 40.725685 | -74.048790 | 44418.0 | Subscriber | 1999.0 | 1.0 | NaN | NaN | NaN | 2 |
| 8 | 67.0 | 2020-10-09 16:21:35.3800 | 2020-10-09 16:22:42.4140 | Newport PATH | 40.727224 | -74.033759 | Newport PATH | 40.727224 | -74.033759 | 45366.0 | Subscriber | 1984.0 | 1.0 | NaN | NaN | NaN | 2 |
| 9 | 68.0 | 2020-10-04 10:25:26.5910 | 2020-10-04 10:26:35.1320 | Warren St | 40.721124 | -74.038051 | Columbus Drive | 40.718355 | -74.038914 | 45150.0 | Subscriber | 1991.0 | 1.0 | NaN | NaN | NaN | 2 |